package com.mouse.mapper;

public class test {
    public static void main(String[] args) {
        System.out.println("SELECT * FROM(SELECT DISTINCT d.* FROM\n" +
                "(SELECT d.* FROM (SELECT gcda.gcid FROM  double_alleles da LEFT JOIN gene_composition_double_alleles gcda ON da.did=gcda.did WHERE da.did=#{did}) res LEFT JOIN gene_composition gc on res.gcid=gc.gcid) gc_res\n" +
                "LEFT JOIN genecategory_genecomposition ggcom ON gc_res.gcid=ggcom.gcid LEFT JOIN gene_category gc ON gc.gid=ggcom.gid\n" +
                "LEFT JOIN gene_homology gh ON gh.gid=gc.gid LEFT JOIN disease d ON d.sid=gh.sid) r WHERE r.sid IS NOT NULL"
        );
    }
}
